L J ✭✭

Overview

Overview

Roles	Member
Badges	3

About Me

About Me

Not much happening here, yet.

Analytics

14

Posts

20

Visits

45

Points

Jan 28, 2025

Join Date

Feb 14, 2025

Last Active

Reactions

• Vote Up 2

  2
• Awesome 3

  3

• Activity
• Discussions1
• Comments13

• Re: Assign a Program Code, without using Auto Number

  L J

  01/31/25
  In order to see what the program code is for a program, rather than leave it blank, my inclination would be to set-up a separate master data sheet that captures all unique programs, and assigns them …
  2 ·

• Re: Record the remaining days on a project

  L J

  01/28/25
  Try something like this: =IF([End Date]@row < TODAY(), "In the past", IF([Start Date]@row > TODAY(), NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(TODAY(), [End Date]@row…
  1 ·

• Re: Conditional Formatting Issue for column formula

  L J

  01/28/25
  Just a couple of quick things to check! 1/ Is the format of the RM % column set to %? If it's Text/Number and showing 40% (vs 0.4) you'll want to correct this. 2/ If your test data is 55% or 110%, yo…
  1 ·